Date & Time Functions

These functions are used for entering, manipulating and calculating dates and times

  • Family: PQL
  • Library: Spreadsheet
  • This function can be used with the Solve plug-in
  • Function List

    DATE

    DATEDIF

    DATEVALUE

    DAY

    DAYS

    DAYS360

    EDATE

    EOMONTH

    HOUR

    ISOWEEKNUM

    MINUTE

    MONTH

    NETWORKDAYS

    NETWORKDAYS.INTL

    NOW

    SECOND

    TIME

    TIMEVALUE

    TODAY

    WEEKDAY

    WEEKNUM

    WORKDAY

    WORKDAY.INTL

    YEAR

    YEARFRAC